Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerSurveyID (FK)(PK) | A unique retailer assigned identifier for the CustomerSurvery. | ID_SRVY_CT | Identity | integer | SurveyQuestion(DO_SRVY_QST) |
SurveyQuestionID (FK)(PK) | Unique retailer assigned identifier for the SurveyQuestion within the context of the CustomerSurvey. | ID_SRVY_QST | Identity | integer | SurveyQuestion(DO_SRVY_QST) |
CustomerID (FK)(PK) | A unique system assigned identifier for the Customer. | ID_CT | Identity | integer | Customer(PA_CT) |
ResponseDate | The date the Customer provided the response to the CustomerSurvey | DC_RSP | DateCalendar | date | |
Response | The response the Customer gave to the particular SurveyQuestion. | DE_RSP | DescriptionShort | varchar(255) | |